How to: Copy a worksheet to a different workbook.
Solution:
Select the worksheet to copy. Select 'Move or Copy Sheet...' from the 'Edit' menu. Specify the name of the destination workbook and the location of the new copy within the destination workbook. Select the 'Create a Copy' check box.
1) Select the worksheet to be copied.
2) Select the 'Edit' menu and select 'Move or Copy Sheet...'. (The Move or Copy dialog box appears.)
NOTE: To copy a worksheet to another workbook, that workbook must be currently open.
3) Select the name of the workbook into which the worksheet should be copied from the 'To Book' drop-down list.
4) Select the location where the copy should be placed in the destination workbook from the 'Before Sheet' list box.
5) Select the 'Create a Copy' check box.
the Create a Copy check box
6) Click 'OK'.
